// db_primary.cpp
// Customizer_Base
// Protea Customizer/Customizer Pro / Business Logic for managing database primary keys
// Copyright (C) 2003, 2004, 2005 eXegeSys, Inc.
// Copyright (C) 2008 Bruce A. James
//
// This program is part of the Protea Project.
//
// The Protea Project is free software; you can redistribute it and/or modify it 
// under the terms of the GNU General Public License as published by the 
// Free Software Foundation, either version 3 of the License, or (at your 
// option) any later version.
//
// The Protea Project is distributed in the hope that it will be useful, but 
// WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY 
// or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License 
// for more details.
// 
// You should have received a copy of the GNU General Public License along 
// with this program.  If not, see <http://www.gnu.org/licenses/>.
//
// Please send correspondence to:
//
// theproteaproject@gmail.com
//

#include "base_setup.h"

void DatabaseAddPrimary( XCBuffer* buffer, XCTransactionVars* vars ) {
	vars->query->MakeFull( SQL_STMT_INSERT, buffer );
	vars->dbtxn->ExecuteSQL( vars->query, SQL_NO_RESULT );
};

void DatabaseDelPrimary( XCBuffer* buffer, XCTransactionVars* vars ) {
	vars->query->MakeFull( SQL_STMT_DELETE, buffer );
	vars->dbtxn->ExecuteSQL( vars->query, SQL_NO_RESULT );
};

void DatabaseChgPrimary( XCBuffer* buffer, XCBuffer* original, XCTransactionVars* vars ) {
	vars->query->MakeFull( SQL_STMT_UPDATE, buffer, original );
	vars->dbtxn->ExecuteSQL( vars->query, SQL_NO_RESULT );
};

bool DatabaseRetrievePrimary( XCBuffer* buffer, XCTransactionVars* vars ) {

	TRANS_INFUNC( DatabaseRetrievePrimary );

	XCDBStatement* stmt = NULL;
	XCSQLGen* query = vars->query;
	bool result;

	try {
		query->MakeFull( SQL_STMT_SELECT, buffer );
		stmt = vars->dbtxn->ExecuteSQL( query );
		result = !stmt->Eof();
		App->CleanupObjects( 1, &stmt );
	} catch( ... ) {
		App->CleanupObjects( 1, &stmt );
		throw;
	};

	TRANS_OUTFUNCRET( result );
};
